﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_AccountGetList]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_AccountGetList];
GO
-------------------------------------------------------------------------------
-- sproc_AccountGetList
-------------------------------------------------------------------------------
CREATE PROCEDURE [dbo].[sproc_AccountGetList]
AS
BEGIN
SET NOCOUNT ON;

SELECT
    TabAccountIndex.UserID,
    CnName
FROM
    dbo.TabAccountIndex,
    dbo.TabAccountInfo
WHERE
    TabAccountIndex.UserID = TabAccountInfo.UserID;

END
GO